Hệ thống quản lý phương tiện trong PHP
1 <?php
2 $id= $_GET['id'];
3
4 $conn=mysqli_connect('localhost','root','','vehicle management');
5 $sql="SELECT * FROM bill WHERE id='$id'";
6 $result=mysqli_query($conn,$sql);
7
8 $std=mysqli_fetch_assoc($result);
9 ?>
10
11
12 <!DOCTYPE html>
13 <html lang="en">
14 <head>
15 <meta charset="utf-8">
16 <meta http-equiv="X-UA-Compatible" content="IE=edge">
17 <meta name="viewport" content="width=device-width, initial-scale=1">
18 <!-- The above 3 meta tags *must* come first in the head; any other head content must come *after* these tags -->
19 <title>Welcome</title>
20
21 <!-- Bootstrap -->
22 <link href="css/bootstrap.min.css" rel="stylesheet">
23
24 <!-- HTML5 shim and Respond.js for IE8 support of HTML5 elements and media queries -->
25 <!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
26 <!--[if lt IE 9]>
27 <script src="https://oss.maxcdn.com/html5shiv/3.7.3/html5shiv.min.js"></script>
28 <script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
29 <![endif]-->
30 </head>
31 <body>
32
33 <br><br><br>
34 <?php include 'navbar.php';?>
35
36 <div class="container">
37 <div class="row">
38 <div class="col-md-2">
39 <a class="btn btn-info" href="index.php">Bill List</a>
40 </div>
41 <div class="col-md-8">
42 <h2>Edit bill</h2>
43 <hr>
44
45
46 <form action="updatebill.php?id=<?php echo '$id'.'$bill_id'; ?>" method="POST">
47
48 <div class="form-group">
49 <label for="name">ID :</label>
50 <input required type="text" class="form-control" name="id" placeholder="vehicle id" value="<?php echo $std['id']?>">
51 </div>
52
53 <div class="form-group">
54 <label for="Roll">Salary :</label>
55 <input required type="text" class="form-control" name="salary" placeholder="Salary" value="<?php echo $std['salary']?>">
56 </div>
57
58 <div class="form-group">
59 <label for="Age">Equipment :</label>
60 <input type="text" class="form-control" name="equipment" placeholder="Equipment" value="<?php echo $std['equipment']?>">
61 </div>
62
63 <div class="form-group">
64 <label for="Address">Oil :</label>
65 <input type="text" class="form-control" name="oil" placeholder="Oil" value="<?php echo $std['oil']?>">
66 </div>
67
68 <div class="form-group">
69 <label for="Mobile">Total cost :</label>
70 <input type="text" class="form-control" name="tcost" placeholder="Total cost" value="<?php echo $std['tcost']?>">
71 </div>
72
73 <button type="submit" class="btn btn-info">Submit</button>
74 </form>
75 </div>
76 </div>
77 </div>
78
79
80 <!-- jQuery (necessary for Bootstrap's JavaScript plugins) -->
81 <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.4/jquery.min.js"></script>
82 <!-- Include all compiled plugins (below), or include individual files as needed -->
83 <script src="js/bootstrap.min.js"></script>
84 </body>
85 </html>